package cn.source.system.service.impl;

import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStream;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import java.util.Map;
import java.util.regex.Matcher;
import java.util.regex.Pattern;

import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.CellType;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.ss.usermodel.WorkbookFactory;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import com.alibaba.excel.EasyExcel;
import com.google.gson.Gson;

import cn.source.system.mapper.GkGradeDocMapper;
import cn.source.system.mapper.SchoolMajorYearAdmissionDetailMapper;
import cn.source.system.mapper.SchoolMajorYearAdmissionDetailZkMapper;
import cn.source.system.mapper.SchoolMajorYearAdmissionMapper;
import cn.source.system.mapper.SchoolMajorYearAdmissionZkMapper;
import cn.source.system.mapper.SchoolPlanMapper;
import cn.source.system.mapper.SchoolPlanZkMapper;
import cn.source.system.mapper.SchoolYearAdmissionMapper;
import cn.source.system.mapper.SchoolYearAdmissionZkMapper;
import cn.hutool.core.date.DateUtil;
import cn.hutool.core.map.MapUtil;
import cn.source.majors.domain.SMajors;
import cn.source.majors.domain.SMajorsZk;
import cn.source.majors.mapper.SMajorsMapper;
import cn.source.majors.mapper.SMajorsZkMapper;
import cn.source.school.domain.School;
import cn.source.school.mapper.SchoolMapper;
import cn.source.system.domain.GkGradeDoc;
import cn.source.system.domain.SchoolMajorYearAdmission;
import cn.source.system.domain.SchoolMajorYearAdmissionDetail;
import cn.source.system.domain.SchoolPlan;
import cn.source.system.domain.SchoolPlanZk;
import cn.source.system.domain.SchoolYearAdmission;
import cn.source.system.domain.SchoolYearAdmissionZk;
import cn.source.system.service.ISchoolYearAdmissionService;
import cn.source.system.service.ISchoolYearAdmissionZkService;


/**
 * 年度学校录取情况Service业务层处理
 * 
 * @author sourcebyte.vip
 * @date 2024-02-20
 */
@Service
public class SchoolYearAdmissionZkServiceImpl implements ISchoolYearAdmissionZkService 
{
	
	private static final Logger log = LoggerFactory.getLogger(SchoolYearAdmissionZkServiceImpl.class);
	
    @Autowired
    private SchoolYearAdmissionZkMapper schoolYearAdmissionMapper;
    
    @Autowired
    private SchoolMajorYearAdmissionZkMapper schoolMajorYearAdmissionMapper;
    
    @Autowired
    private SchoolMajorYearAdmissionDetailZkMapper schoolMajorYearAdmissionDetailMapper;
    
    @Autowired
    private GkGradeDocMapper gkGradeDocMapper;
    
    
    @Autowired
    private SMajorsZkMapper majorsZkMapper;
    
    @Autowired
    private SchoolMapper schoolMapper;
    
    
    @Autowired
    private SchoolPlanZkMapper schoolPlanZkMapper;

    /**
     * 查询年度学校录取情况
     * 
     * @param id 年度学校录取情况主键
     * @return 年度学校录取情况
     */
    @Override
    public SchoolYearAdmissionZk selectSchoolYearAdmissionById(Long id)
    {
        return schoolYearAdmissionMapper.selectSchoolYearAdmissionById(id);
    }

    /**
     * 查询年度学校录取情况列表
     * 
     * @param schoolYearAdmission 年度学校录取情况
     * @return 年度学校录取情况
     */
    @Override
    public List<SchoolYearAdmissionZk> selectSchoolYearAdmissionList(SchoolYearAdmissionZk schoolYearAdmission)
    {
        return schoolYearAdmissionMapper.selectSchoolYearAdmissionList(schoolYearAdmission);
    }

    /**
     * 新增年度学校录取情况
     * 
     * @param schoolYearAdmission 年度学校录取情况
     * @return 结果
     */
    @Override
    public int insertSchoolYearAdmission(SchoolYearAdmissionZk schoolYearAdmission)
    {
        return schoolYearAdmissionMapper.insertSchoolYearAdmission(schoolYearAdmission);
    }

    /**
     * 修改年度学校录取情况
     * 
     * @param schoolYearAdmission 年度学校录取情况
     * @return 结果
     */
    @Override
    public int updateSchoolYearAdmission(SchoolYearAdmissionZk schoolYearAdmission)
    {
        return schoolYearAdmissionMapper.updateSchoolYearAdmission(schoolYearAdmission);
    }

    /**
     * 批量删除年度学校录取情况
     * 
     * @param ids 需要删除的年度学校录取情况主键
     * @return 结果
     */
    @Override
    public int deleteSchoolYearAdmissionByIds(Long[] ids)
    {
        return schoolYearAdmissionMapper.deleteSchoolYearAdmissionByIds(ids);
    }

    /**
     * 删除年度学校录取情况信息
     * 
     * @param id 年度学校录取情况主键
     * @return 结果
     */
    @Override
    public int deleteSchoolYearAdmissionById(Long id)
    {
        return schoolYearAdmissionMapper.deleteSchoolYearAdmissionById(id);
    }
    
   
}
